Solution to Exercise 2
Solution to exercise 2.
We'll cover the following
Solution #1#
The solution will also work without using the aliases as seen below:
Solution #2#
Explanation#
We will perform an INNER JOIN on the two tables to retrieve the common records and then the WHERE clause is used to specify the condition that SALARY has to be in a certain range.
It is important to note that we joined the two tables because part of the information we needed was in the EMPLOYEE table (Full_Name) and the other half in the SALARY table (Salary).
The slides below help to visualize the solution:
1 of 2
Exercise 2
Exercise 3
Mark as Completed
Report an Issue
